Tabela LEpisodeInsurance

Definicja tabeli LEpisodeInsurance

Name

LEpisodeInsurance

Code

LEpisodeInsurance

Comment

 


Lista kolumn tabeli LEpisodeInsurance

Name

Code

LEpisodeInsuranceID

LEpisodeInsuranceID

EpisodeID

EpisodeID

InsuranceID

InsuranceID

StartDT

StartDT

StopDT

StopDT

Active

Active

NfzLEpisodeInsuranceID

NfzLEpisodeInsuranceID


Kolumna LEpisodeInsuranceID tabeli LEpisodeInsurance

Definicja kolumny LEpisodeInsuranceID tabeli LEpisodeInsurance

Name

LEpisodeInsuranceID

Code

LEpisodeInsuranceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Unikalny identyfikator okresu finansowania zestawu swiadczen z danego tytylu


Kolumna EpisodeID tabeli LEpisodeInsurance

Definicja kolumny EpisodeID tabeli LEpisodeInsurance

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(20)

Mandatory

Yes

Comment

 


Kolumna InsuranceID tabeli LEpisodeInsurance

Definicja kolumny InsuranceID tabeli LEpisodeInsurance

Name

InsuranceID

Code

InsuranceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StartDT tabeli LEpisodeInsurance

Definicja kolumny StartDT tabeli LEpisodeInsurance

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

Data poczatku okresu finansowania zestawu swiadczen z danego tytulu


Kolumna StopDT tabeli LEpisodeInsurance

Definicja kolumny StopDT tabeli LEpisodeInsurance

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

Data konca okresu finansowania zestawu swiadczen z danego tytulu


Kolumna Active tabeli LEpisodeInsurance

Definicja kolumny Active tabeli LEpisodeInsurance

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna NfzLEpisodeInsuranceID tabeli LEpisodeInsurance

Definicja kolumny NfzLEpisodeInsuranceID tabeli LEpisodeInsurance

Name

NfzLEpisodeInsuranceID

Code

NfzLEpisodeInsuranceID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID okresu finansowania zestawu swiadczen z danego tytulu w ramach zestawu swiadczen - wartosc dla atrybut id-okresu w xml


Lista kluczy tabeli LEpisodeInsurance

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LEpisodeInsurance

Definicja klucza Identifier_1 tabeli LEpisodeInsurance

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment